Kelly Moore
Kelly Moore
-
Re: VLOOKUP not pulling in correct data when duplicate names
Excellent! I’m so glad you got it to work. I encourage you to explore the COLLECT function. Although it must be paired with something, it can be used with so many other functions. I think it is one o…1 · -
Re: How to format "row" when inserting record into Smartsheet
Hey @SM_Trailhead I'm not sure if it is the same, but I had to figure out a similar problem when using power automate to insert excel row into smartsheet. I had to use a JSON array to solve it. Perha…1 · -
Re: Fonctions: FIND vs CONTAINS
Hey @Cbastien I wondered if you need to use either CONTAINS or Find. Is the value in [Type] in a single select dropdown, that is , a drop down where only one answer is allowed at a time? If so, CONTA…1 · -
Re: Competency Framework
Hey @peter65516 Not knowing your sheet or data input process, I'm not sure if it would be necessary to move rows to another sheet (using built-in smartsheet automation) or if you could capture all th…1 · -
Re: Convert Measure Symbol to number & Average
@MeganJF Try this =AVG(IF([Value to User]@row = "No Pain", 4, IF([Value to User]@row = "Mild", 3, IF([Value to User]@row = "Moderate", 2, IF([Value to User]@row = "…1 ·
